USE [Construarte]
GO

/****** Object: Table [dbo].[Etapa] Script Date: 31/08/2013 16:39:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Etapa] (
    [EtapaId]      INT            IDENTITY (1, 1) NOT NULL,
    [DescEtapa]    NVARCHAR (150) NULL,
    [DtMesEtapa]   DATE           NOT NULL,
    [PorcPrevista] NVARCHAR (3)   NOT NULL,
    [PorcAtingida] NVARCHAR (3)   NULL,
    [TarefaId]     INT            NOT NULL,
    [OrdemEtapa]   INT            NOT NULL,
    PRIMARY KEY CLUSTERED ([EtapaId] ASC),
    CONSTRAINT [FK_Etapa_Tarefa] FOREIGN KEY ([TarefaId]) REFERENCES [dbo].[Tarefa] ([TarefaId])
);



